Convert SQL Server query to Oracle equivalent

join shbcf.ru